<%@ page import="java.sql.*, studentportal.*"%>

<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>Student Portal</title>
<meta name="Microsoft Theme" content="indust 011">
</head>

<body background="indtextb.jpg" bgcolor="#FFFFFF" text="#000000" link="#3366CC" vlink="#666666" alink="#996600">

<font face="Trebuchet MS, Arial, Helvetica"><!--mstheme--></font>
	<table border="0" width="100%" bordercolorlight="#666666" bordercolordark="#000000">
  <tr>
    <td width="100%"><img border="0" src="StdPrtlbanner.jpg" width="846" height="65"><!--mstheme--><font face="Trebuchet MS, Arial, Helvetica">&nbsp;<!--mstheme--></font></td>
  </tr>
<table border="0" width="100%">
  <tr>
    <td width="23%">
      <p align="center">&nbsp;<a href="Infrastructure.html">Infrastructure</a></td>
    <td width="17%">
      <p align="center"><a href="Course_OfferedView_Main.jsp">Courses</a></td>
    <td width="20%">
      <p align="center"><a href="Faculties_Available_Main.jsp">Faculty</a></td>
    <td width="20%">
      <p align="center"><a href="Library.html">Library</a></td>
	  	      <td width="20%">
      <p align="center"><a href="papers.html">Previous Papers</a></td>
    <td width="20%">
      <p align="center"><a href="Home.html">Home</a>/<a href="CollegeHome.html">Back</a></td>
  </tr>
</table>

<font face="Trebuchet MS, Arial, Helvetica">
	<form method="POST" action="">
  
	  <p>
			<table align="center" border="0">
				<tr>
					<th>Faculty ID</th>
					<th>Faculty Name</th>
					<th>Faculty E-Mail</th>
					<th>Faculty Dept</th>
					<th>Faculty Deg</th>
				</tr>
				<%
					Connection con=MySQLDriver.getConnection(); 
					Statement st=con.createStatement();
					Statement st1=con.createStatement();
					Statement st2=con.createStatement();
					System.out.println("After Statement");
					ResultSet rs1=null;
					ResultSet rs2=null;
					ResultSet rs=st.executeQuery("select faculty_id, faculty_name, faculty_address, faculty_dob, faculty_phone, faculty_email, faculty_join_date, (select branch_name from branch_master where faculty_master.faculty_dept_id=branch_master.branch_id), (select desigantion_name from designation_master where faculty_master.faculty_designation_id=designation_master.designation_id), faculty_login_name, faculty_lstatus from faculty_master");
					System.out.println("After ResultSet");
					while(rs.next())
					{
						rs1=null;
						rs2=null;
						System.out.println("In While");
						
				%>
					
					<tr>
						<td align="center"><%=rs.getString(1)%></td>
						<td align="center"><%=rs.getString(2)%></td>
						<td align="center"><%=rs.getString(6)%></td>
						<td align="center"><%=rs.getString(8)%></td>
						<td align="center"><%=rs.getString(9)%></td>
				<%
					}
					rs.close();
					st.close();
					con.close();
				%>
					</tr>
			</table>
	  </p>
	</form>
</font>

</body>

</html>
